create table sys_oper_log
(
    oper_id        bigint identity
        constraint PK__sys_oper__34723BF99AD6B16E
            primary key,
    title          nvarchar(50)
        constraint DF_sys_oper_log_title default '',
    business_type  int
        constraint DF_sys_oper_log_business_type default 0,
    method         nvarchar(100)
        constraint DF_sys_oper_log_method default '',
    request_method nvarchar(10)
        constraint DF_sys_oper_log_request_method default '',
    operator_type  int
        constraint DF_sys_oper_log_operator_type default 0,
    oper_name      nvarchar(50)
        constraint DF_sys_oper_log_oper_name default '',
    dept_name      nvarchar(50)
        constraint DF_sys_oper_log_dept_name default '',
    oper_url       nvarchar(255)
        constraint DF_sys_oper_log_oper_url default '',
    oper_ip        nvarchar(128)
        constraint DF_sys_oper_log_oper_ip default '',
    oper_location  nvarchar(255)
        constraint DF_sys_oper_log_oper_location default '',
    oper_param     nvarchar(2000)
        constraint DF_sys_oper_log_oper_param default '',
    json_result    nvarchar(2000)
        constraint DF_sys_oper_log_json_result default '',
    status         int
        constraint DF_sys_oper_log_status default 0,
    error_msg      nvarchar(2000)
        constraint DF_sys_oper_log_error_msg default '',
    oper_time      datetime2(0)
)
go

exec sp_addextendedproperty 'MS_Description', '操作日志记录', 'SCHEMA', 'dbo', 'TABLE', 'sys_oper_log'
go

exec sp_addextendedproperty 'MS_Description', '日志主键', 'SCHEMA', 'dbo', 'TABLE', 'sys_oper_log', 'COLUMN', 'oper_id'
go

exec sp_addextendedproperty 'MS_Description', '模块标题', 'SCHEMA', 'dbo', 'TABLE', 'sys_oper_log', 'COLUMN', 'title'
go

exec sp_addextendedproperty 'MS_Description', '业务类型（0其它 1新增 2修改 3删除）', 'SCHEMA', 'dbo', 'TABLE', 'sys_oper_log',
     'COLUMN', 'business_type'
go

exec sp_addextendedproperty 'MS_Description', '方法名称', 'SCHEMA', 'dbo', 'TABLE', 'sys_oper_log', 'COLUMN', 'method'
go

exec sp_addextendedproperty 'MS_Description', '请求方式', 'SCHEMA', 'dbo', 'TABLE', 'sys_oper_log', 'COLUMN',
     'request_method'
go

exec sp_addextendedproperty 'MS_Description', '操作类别（0其它 1后台用户 2手机端用户）', 'SCHEMA', 'dbo', 'TABLE', 'sys_oper_log',
     'COLUMN', 'operator_type'
go

exec sp_addextendedproperty 'MS_Description', '操作人员', 'SCHEMA', 'dbo', 'TABLE', 'sys_oper_log', 'COLUMN', 'oper_name'
go

exec sp_addextendedproperty 'MS_Description', '部门名称', 'SCHEMA', 'dbo', 'TABLE', 'sys_oper_log', 'COLUMN', 'dept_name'
go

exec sp_addextendedproperty 'MS_Description', '请求URL', 'SCHEMA', 'dbo', 'TABLE', 'sys_oper_log', 'COLUMN', 'oper_url'
go

exec sp_addextendedproperty 'MS_Description', '主机地址', 'SCHEMA', 'dbo', 'TABLE', 'sys_oper_log', 'COLUMN', 'oper_ip'
go

exec sp_addextendedproperty 'MS_Description', '操作地点', 'SCHEMA', 'dbo', 'TABLE', 'sys_oper_log', 'COLUMN',
     'oper_location'
go

exec sp_addextendedproperty 'MS_Description', '请求参数', 'SCHEMA', 'dbo', 'TABLE', 'sys_oper_log', 'COLUMN', 'oper_param'
go

exec sp_addextendedproperty 'MS_Description', '返回参数', 'SCHEMA', 'dbo', 'TABLE', 'sys_oper_log', 'COLUMN', 'json_result'
go

exec sp_addextendedproperty 'MS_Description', '操作状态（0正常 1异常）', 'SCHEMA', 'dbo', 'TABLE', 'sys_oper_log', 'COLUMN',
     'status'
go

exec sp_addextendedproperty 'MS_Description', '错误消息', 'SCHEMA', 'dbo', 'TABLE', 'sys_oper_log', 'COLUMN', 'error_msg'
go

exec sp_addextendedproperty 'MS_Description', '操作时间', 'SCHEMA', 'dbo', 'TABLE', 'sys_oper_log', 'COLUMN', 'oper_time'
go

INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (1, N'定时任务', 2, N'com.ruoyi.quartz.controller.SysJobController.edit()', N'PUT', 1, N'admin', null, N'/monitor/job', N'127.0.0.1', N'内网IP', N'{"jobName":"系统默认（无参）","concurrent":"1","remark":"","jobGroup":"DEFAULT","params":{},"cronExpression":"0/10 * * * * ?","jobId":1,"createBy":"admin","nextValidTime":1638594990000,"createTime":1638541348000,"updateBy":"admin","invokeTarget":"ryTask.ryNoParams","misfirePolicy":"3","status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2021-12-04 13:16:20');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (2, N'定时任务', 2, N'com.ruoyi.quartz.controller.SysJobController.changeStatus()', N'PUT', 1, N'admin', null, N'/monitor/job/changeStatus', N'127.0.0.1', N'内网IP', N'{"params":{},"jobId":1,"misfirePolicy":"0","status":"1"}', N'{"msg":"操作成功","code":200}', 0, null, N'2021-12-04 13:16:24');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (3, N'代码生成', 6, N'com.ruoyi.generator.controller.GenController.importTableSave()', N'POST', 1, N'admin', null, N'/tool/gen/importTable', N'127.0.0.1', N'内网IP', N'sys_dept', N'{"msg":"操作成功","code":200}', 0, null, N'2021-12-04 14:56:33');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (4, N'代码生成', 2, N'com.ruoyi.generator.controller.GenController.editSave()', N'PUT', 1, N'admin', null, N'/tool/gen', N'127.0.0.1', N'内网IP', N'{"sub":false,"subTableName":"","functionAuthor":"ruoyi","columns":[{"capJavaField":"DeptId","usableColumn":false,"columnId":1,"increment":false,"insert":true,"required":false,"superColumn":false,"isInsert":"1","javaField":"deptId","htmlType":"input","edit":false,"query":false,"columnComment":"部门id","sort":1,"list":false,"params":{},"javaType":"Long","columnType":"bigint","createBy":"admin","isPk":"1","createTime":1638600993000,"tableId":1,"pk":true,"columnName":"dept_id"},{"capJavaField":"ParentId","usableColumn":true,"columnId":2,"increment":false,"insert":true,"isList":"1","required":false,"superColumn":true,"isInsert":"1","javaField":"parentId","htmlType":"input","edit":true,"query":true,"columnComment":"父部门id","isQuery":"1","sort":2,"list":true,"params":{},"javaType":"Long","columnType":"bigint","createBy":"admin","createTime":1638600993000,"isEdit":"1","tableId":1,"pk":false,"columnName":"parent_id"},{"capJavaField":"Ancestors","usableColumn":false,"columnId":3,"increment":false,"insert":true,"isList":"1","required":false,"superColumn":true,"isInsert":"1","javaField":"ancestors","htmlType":"input","edit":true,"query":true,"columnComment":"祖级列表","isQuery":"1","sort":3,"list":true,"params":{},"javaType":"String","columnType":"nvarchar","createBy":"admin","createTime":1638600993000,"isEdit":"1","tableId":1,"pk":false,"columnName":"ancestors"},{"capJavaField":"DeptName","usableColumn":false,"columnId":4,"increment":false,"insert":true,"isList":"1","required":false,"superColumn":false,"isInsert":"1","javaField":"deptName","htmlType":"input","edit":true,"query":true,"columnComment":"部门名称","isQuery":"1","sort":4,"list":true,"params":{},"javaType":"String","queryType":"LIKE","columnType":"nvarchar","createBy":"admin","createTime":1638600993000,"isEdit":"1","tableId":1,"pk":false,"columnName":"dept_name"},{"capJavaField":"OrderNum","usableColumn":true,"columnId":5,"increment":false,"insert":true,"isList":"1","required":false,"superColumn":true,"isInsert":"1","javaField"', N'{"msg":"操作成功","code":200}', 0, null, N'2021-12-04 14:57:19');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (5, N'代码生成', 8, N'com.ruoyi.generator.controller.GenController.batchGenCode()', N'GET', 1, N'admin', null, N'/tool/gen/batchGenCode', N'127.0.0.1', N'内网IP', N'{}', null, 0, null, N'2021-12-04 14:57:26');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (6, N'代码生成', 3, N'com.ruoyi.generator.controller.GenController.remove()', N'DELETE', 1, N'admin', null, N'/tool/gen/1', N'127.0.0.1', N'内网IP', N'{tableIds=1}', N'{"msg":"操作成功","code":200}', 0, null, N'2021-12-04 14:57:42');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (7, N'通知公告', 2, N'com.ruoyi.web.controller.system.SysNoticeController.edit()', N'PUT', 1, N'admin', null, N'/system/notice', N'127.0.0.1', N'内网IP', N'{"noticeContent":"<p>乱码？           </p>","createBy":"admin","createTime":1638541349000,"updateBy":"admin","noticeType":"1","remark":"管理员","params":{},"noticeId":2,"noticeTitle":"维护通知：2018-07-01 若依系统凌晨维护","status":"0"}', null, 1, N'
### Error updating database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 不允许从数据类型 nvarchar 到 varbinary(max) 的隐式转换。请使用 CONVERT 函数来运行此查询。
### The error may exist in file [F:\JAVA\RuoYi\RuoYi-Vue\ruoyi-system\target\classes\mapper\system\SysNoticeMapper.xml]
### The error may involve com.ruoyi.system.mapper.SysNoticeMapper.updateNotice-Inline
### The error occurred while setting parameters
### SQL: update sys_notice          SET notice_title = ?,              notice_type = ?,              notice_content = ?,              status = ?,              update_by = ?,     update_time = getdate()          where notice_id = ?
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 不允许从数据类型 nvarchar 到 varbinary(max) 的隐式转换。请使用 CONVERT 函数来运行此查询。
; uncategorized SQLException; SQL state [S0003]; error code [257]; 不允许从数据类型 nvarchar 到 varbinary(max) 的隐式转换。请使用 CONVERT 函数来运行此查询。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 不允许从数据类型 nvarchar 到 varbinary(max) 的隐式转换。请使用 CONVERT 函数来运行此查询。', N'2021-12-04 15:01:11');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (8, N'通知公告', 2, N'com.ruoyi.web.controller.system.SysNoticeController.edit()', N'PUT', 1, N'admin', null, N'/system/notice', N'127.0.0.1', N'内网IP', N'{"noticeContent":"<p>1111111111</p>","createBy":"admin","createTime":1638541349000,"updateBy":"admin","noticeType":"2","remark":"管理员","params":{},"noticeId":1,"noticeTitle":"温馨提醒：2018-07-01 若依新版本发布啦","status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2021-12-04 15:19:59');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (9, N'通知公告', 2, N'com.ruoyi.web.controller.system.SysNoticeController.edit()', N'PUT', 1, N'admin', null, N'/system/notice', N'127.0.0.1', N'内网IP', N'{"noticeContent":"<p>乱码？？  </p>","createBy":"admin","createTime":1638541349000,"updateBy":"admin","noticeType":"1","remark":"管理员","params":{},"noticeId":2,"noticeTitle":"维护通知：2018-07-01 若依系统凌晨维护","status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2021-12-04 15:20:12');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (10, N'通知公告', 2, N'com.ruoyi.web.controller.system.SysNoticeController.edit()', N'PUT', 1, N'admin', null, N'/system/notice', N'127.0.0.1', N'内网IP', N'{"noticeContent":"<p><img src=\"/dev-api/profile/upload/2021/12/04/98ff572f-d8ba-4294-ba17-a741576465ff.png\">乱码？？  </p>","createBy":"admin","createTime":1638541349000,"updateBy":"admin","noticeType":"1","remark":"管理员","updateTime":1638602412000,"params":{},"noticeId":2,"noticeTitle":"维护通知：2018-07-01 若依系统凌晨维护","status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2021-12-04 15:20:27');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (11, N'通知公告', 2, N'com.ruoyi.web.controller.system.SysNoticeController.edit()', N'PUT', 1, N'admin', null, N'/system/notice', N'127.0.0.1', N'内网IP', N'{"noticeContent":"<p><img src=\"/dev-api/profile/upload/2021/12/04/f1e00aba-0182-46b0-9c65-7804dfd0ea4e.png\"></p>","createBy":"admin","createTime":1638541349000,"updateBy":"admin","noticeType":"1","remark":"管理员","updateTime":1638602427000,"params":{},"noticeId":2,"noticeTitle":"维护通知：2018-07-01 若依系统凌晨维护","status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2021-12-04 15:21:12');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (12, N'菜单管理', 3, N'com.ruoyi.web.controller.system.SysMenuController.remove()', N'DELETE', 1, N'admin', null, N'/system/menu/4', N'127.0.0.1', N'内网IP', N'{menuId=4}', N'{"msg":"菜单已分配,不允许删除","code":500}', 0, null, N'2021-12-04 15:22:07');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (13, N'角色管理', 2, N'com.ruoyi.web.controller.system.SysRoleController.edit()', N'PUT', 1, N'admin', null, N'/system/role', N'127.0.0.1', N'内网IP', N'{"flag":false,"roleId":2,"admin":false,"remark":"普通角色","dataScope":"2","delFlag":"0","params":{},"roleSort":"2","deptCheckStrictly":true,"createTime":1638541333000,"menuCheckStrictly":true,"roleKey":"common","roleName":"普通角色","menuIds":[1,100,1001,1002,1003,1004,1005,1006,1007,101,1008,1009,1010,1011,1012,102,1013,1014,1015,1016,103,1017,1018,1019,1020,104,1021,1022,1023,1024,1025,105,1026,1027,1028,1029,1030,106,1031,1032,1033,1034,1035,107,1036,1037,1038,1039,108,500,1040,1041,1042,501,1043,1044,1045,2,109,1046,1047,1048,110,1049,1050,1051,1052,1053,1054,111,112,113,3,114,115,1055,1056,1058,1057,1059,1060,116],"status":"0"}', null, 1, N'
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。
### The error may exist in file [F:\JAVA\RuoYi\RuoYi-Vue\ruoyi-system\target\classes\mapper\system\SysRoleMapper.xml]
### The error may involve com.ruoyi.system.mapper.SysRoleMapper.checkRoleNameUnique-Inline
### The error occurred while setting parameters
### SQL: select distinct r.role_id, r.role_name, r.role_key, r.role_sort, r.data_scope, r.menu_check_strictly, r.dept_check_strictly,             r.status, r.del_flag, r.create_time, r.remark         from sys_role r          left join sys_user_role ur on ur.role_id = r.role_id          left join sys_user u on u.user_id = ur.user_id          left join sys_dept d on u.dept_id = d.dept_id          where r.role_name=? limit 1
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。
; uncategorized SQLException; SQL state [S0001]; error code [102]; “limit”附近有语法错误。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。', N'2021-12-04 15:22:16');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (14, N'角色管理', 2, N'com.ruoyi.web.controller.system.SysRoleController.edit()', N'PUT', 1, N'admin', null, N'/system/role', N'127.0.0.1', N'内网IP', N'{"flag":false,"roleId":2,"admin":false,"remark":"普通角色","dataScope":"2","delFlag":"0","params":{},"roleSort":"2","deptCheckStrictly":true,"createTime":1638541333000,"updateBy":"admin","menuCheckStrictly":true,"roleKey":"common","roleName":"普通角色","menuIds":[1,100,1001,1002,1003,1004,1005,1006,1007,101,1008,1009,1010,1011,1012,102,1013,1014,1015,1016,103,1017,1018,1019,1020,104,1021,1022,1023,1024,1025,105,1026,1027,1028,1029,1030,106,1031,1032,1033,1034,1035,107,1036,1037,1038,1039,108,500,1040,1041,1042,501,1043,1044,1045,2,109,1046,1047,1048,110,1049,1050,1051,1052,1053,1054,111,112,113,3,114,115,1055,1056,1058,1057,1059,1060,116],"status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2021-12-04 15:44:20');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (15, N'菜单管理', 3, N'com.ruoyi.web.controller.system.SysMenuController.remove()', N'DELETE', 1, N'admin', null, N'/system/menu/4', N'127.0.0.1', N'内网IP', N'{menuId=4}', N'{"msg":"操作成功","code":200}', 0, null, N'2021-12-04 15:44:29');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (16, N'用户管理', 2, N'com.ruoyi.web.controller.system.SysUserController.edit()', N'PUT', 1, N'admin', null, N'/system/user', N'127.0.0.1', N'内网IP', N'{"roles":[{"flag":false,"roleId":2,"admin":false,"dataScope":"2","params":{},"roleSort":"2","deptCheckStrictly":false,"menuCheckStrictly":false,"roleKey":"common","roleName":"普通角色","status":"0"}],"phonenumber":"15666666666","admin":false,"loginDate":1638541332000,"remark":"测试员","delFlag":"0","password":"","updateBy":"admin","postIds":[2],"loginIp":"127.0.0.1","email":"ry@qq.com","nickName":"若依","sex":"1","deptId":105,"avatar":"","dept":{"deptName":"测试部门","leader":"若依","deptId":105,"orderNum":"3","params":{},"parentId":101,"children":[],"status":"0"},"params":{},"userName":"ry","userId":2,"createBy":"admin","roleIds":[2],"createTime":1638541332000,"status":"1"}', N'{"msg":"操作成功","code":200}', 0, null, N'2021-12-04 15:59:05');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (17, N'用户管理', 2, N'com.ruoyi.web.controller.system.SysUserController.changeStatus()', N'PUT', 1, N'admin', null, N'/system/user/changeStatus', N'127.0.0.1', N'内网IP', N'{"admin":false,"updateBy":"admin","params":{},"userId":2,"status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2021-12-04 15:59:09');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (18, N'用户管理', 1, N'com.ruoyi.web.controller.system.SysUserController.add()', N'POST', 1, N'admin', null, N'/system/user', N'127.0.0.1', N'内网IP', N'{"phonenumber":"18845678900","admin":false,"password":"$2a$10$5wgjaf3wHruu67axJAmd8uWSG/yK24hKKVH8CaQuQh2OYyOU6e.Bm","postIds":[],"email":"12345@qq.com","nickName":"test","sex":"0","params":{},"userName":"test","userId":3,"createBy":"admin","roleIds":[],"status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2021-12-14 21:51:57');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (19, N'用户管理', 2, N'com.ruoyi.web.controller.system.SysUserController.edit()', N'PUT', 1, N'admin', null, N'/system/user', N'127.0.0.1', N'内网IP', N'{"roles":[],"phonenumber":"18845678900","admin":false,"delFlag":"0","password":"","updateBy":"admin","postIds":[],"loginIp":"","email":"12345@qq.com","nickName":"test","sex":"0","avatar":"","params":{},"userName":"test","userId":3,"createBy":"admin","roleIds":[],"createTime":1639489917000,"status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2021-12-14 21:52:10');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (20, N'用户管理', 2, N'com.ruoyi.web.controller.system.SysUserController.edit()', N'PUT', 1, N'admin', null, N'/system/user', N'127.0.0.1', N'内网IP', N'{"roles":[],"phonenumber":"18845678900","admin":false,"delFlag":"0","password":"","updateBy":"admin","postIds":[],"loginIp":"","email":"12345@qq.com","nickName":"test","sex":"0","deptId":100,"avatar":"","params":{},"userName":"test","userId":3,"createBy":"admin","roleIds":[],"createTime":1639489917000,"status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2021-12-14 21:52:41');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (21, N'角色管理', 1, N'com.ruoyi.web.controller.system.SysRoleController.add()', N'POST', 1, N'admin', null, N'/system/role', N'127.0.0.1', N'内网IP', N'{"flag":false,"roleId":3,"admin":false,"params":{},"roleSort":"999","deptCheckStrictly":true,"createBy":"admin","menuCheckStrictly":true,"roleKey":"Livon","roleName":"Livon","deptIds":[],"menuIds":[1,104,1021,1022,1023,1024,1025],"status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-22 14:01:52');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (22, N'字典类型', 1, N'com.ruoyi.web.controller.system.SysDictTypeController.add()', N'POST', 1, N'admin', null, N'/system/dict/type', N'127.0.0.1', N'内网IP', N'{"createBy":"admin","dictName":"民族（中国）","params":{},"dictType":"hr_dict_china_nations","status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-22 15:04:31');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (23, N'字典数据', 1, N'com.ruoyi.web.controller.system.SysDictDataController.add()', N'POST', 1, N'admin', null, N'/system/dict/data', N'127.0.0.1', N'内网IP', N'{"dictValue":"01","listClass":"default","dictSort":1,"params":{},"dictType":"hr_dict_china_nations","dictLabel":"汉","createBy":"admin","default":false,"status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-22 15:07:23');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (24, N'用户管理', 2, N'com.ruoyi.web.controller.system.SysUserController.edit()', N'PUT', 1, N'admin', null, N'/system/user', N'127.0.0.1', N'内网IP', N'{"roles":[],"phonenumber":"18845678900","admin":false,"delFlag":"0","password":"","updateBy":"admin","postIds":[],"loginIp":"","email":"12345@qq.com","nickName":"test","sex":"0","deptId":100,"avatar":"","dept":{"deptName":"若依科技","leader":"若依","deptId":100,"orderNum":"0","params":{},"parentId":0,"children":[],"status":"0"},"params":{},"userName":"test","userId":3,"createBy":"admin","roleIds":[2],"createTime":1639489917000,"status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-25 16:46:39');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (25, N'代码生成', 6, N'com.ruoyi.generator.controller.GenController.importTableSave()', N'POST', 1, N'admin', null, N'/tool/gen/importTable', N'127.0.0.1', N'内网IP', N'hr_user', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 11:30:36');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (26, N'代码生成', 6, N'com.ruoyi.generator.controller.GenController.importTableSave()', N'POST', 1, N'admin', null, N'/tool/gen/importTable', N'127.0.0.1', N'内网IP', N'hr_user_cv', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 11:50:55');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (27, N'代码生成', 3, N'com.ruoyi.generator.controller.GenController.remove()', N'DELETE', 1, N'admin', null, N'/tool/gen/1', N'127.0.0.1', N'内网IP', N'{tableIds=1}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 12:02:21');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (28, N'代码生成', 6, N'com.ruoyi.generator.controller.GenController.importTableSave()', N'POST', 1, N'admin', null, N'/tool/gen/importTable', N'127.0.0.1', N'内网IP', N'hr_user', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 12:02:28');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (29, N'菜单管理', 1, N'com.ruoyi.web.controller.system.SysMenuController.add()', N'POST', 1, N'admin', null, N'/system/menu', N'127.0.0.1', N'内网IP', N'{"visible":"0","orderNum":101,"menuName":"1","params":{},"parentId":0,"isCache":"0","path":"1","createBy":"admin","children":[],"isFrame":"1","menuType":"M","status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 13:11:11');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (30, N'代码生成', 2, N'com.ruoyi.generator.controller.GenController.editSave()', N'PUT', 1, N'admin', null, N'/tool/gen', N'127.0.0.1', N'内网IP', N'{"sub":true,"subTableName":"hr_user_cv","functionAuthor":"ruoyi","columns":[{"capJavaField":"UserUuid","usableColumn":false,"columnId":12,"increment":false,"insert":true,"dictType":"","required":false,"superColumn":false,"updateBy":"","isInsert":"1","javaField":"userUuid","htmlType":"input","edit":false,"query":false,"columnComment":"主键","sort":1,"list":false,"params":{},"javaType":"String","queryType":"EQ","columnType":"varchar","createBy":"admin","isPk":"1","createTime":1646020948000,"tableId":3,"pk":true,"columnName":"user_uuid"},{"capJavaField":"FkSysUserId","usableColumn":false,"columnId":13,"increment":false,"insert":true,"isList":"1","dictType":"","required":false,"superColumn":false,"updateBy":"","isInsert":"1","javaField":"fkSysUserId","htmlType":"input","edit":true,"query":true,"columnComment":"系统用户ID-外键","isQuery":"1","sort":2,"list":true,"params":{},"javaType":"Long","queryType":"LIKE","columnType":"bigint","createBy":"admin","createTime":1646020948000,"isEdit":"1","tableId":3,"pk":false,"columnName":"fk_sys_user_id"},{"capJavaField":"IdNum","usableColumn":false,"columnId":14,"increment":false,"insert":true,"isList":"1","dictType":"","required":false,"superColumn":false,"updateBy":"","isInsert":"1","javaField":"idNum","htmlType":"input","edit":true,"query":true,"columnComment":"身份证号","isQuery":"1","sort":3,"list":true,"params":{},"javaType":"String","queryType":"LIKE","columnType":"varchar","createBy":"admin","createTime":1646020948000,"isEdit":"1","tableId":3,"pk":false,"columnName":"id_num"},{"capJavaField":"Remark","usableColumn":true,"columnId":15,"increment":false,"insert":true,"isList":"1","dictType":"","required":false,"superColumn":true,"updateBy":"","isInsert":"1","javaField":"remark","htmlType":"input","edit":true,"query":false,"columnComment":"备注","sort":4,"list":true,"params":{},"javaType":"String","queryType":"LIKE","columnType":"nvarchar","createBy":"admin","createTime":1646020948000,"isEdit":"1","tableId":3,"pk":false,"columnName":"remark"', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 13:13:49');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (31, N'代码生成', 8, N'com.ruoyi.generator.controller.GenController.batchGenCode()', N'GET', 1, N'admin', null, N'/tool/gen/batchGenCode', N'127.0.0.1', N'内网IP', N'{}', null, 0, null, N'2022-02-28 13:14:15');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (32, N'代码生成', 2, N'com.ruoyi.generator.controller.GenController.editSave()', N'PUT', 1, N'admin', null, N'/tool/gen', N'127.0.0.1', N'内网IP', N'{"sub":true,"subTableName":"hr_user_cv","functionAuthor":"ruoyi","columns":[{"capJavaField":"UserUuid","usableColumn":false,"columnId":12,"increment":false,"insert":true,"dictType":"","required":false,"superColumn":false,"updateBy":"","isInsert":"1","javaField":"userUuid","htmlType":"input","edit":false,"query":false,"columnComment":"主键","updateTime":1646025229000,"sort":1,"list":false,"params":{},"javaType":"String","queryType":"EQ","columnType":"varchar","createBy":"admin","isPk":"1","createTime":1646020948000,"tableId":3,"pk":true,"columnName":"user_uuid"},{"capJavaField":"FkSysUserId","usableColumn":false,"columnId":13,"increment":false,"insert":true,"isList":"1","dictType":"","required":false,"superColumn":false,"updateBy":"","isInsert":"1","javaField":"fkSysUserId","htmlType":"input","edit":true,"query":true,"columnComment":"系统用户ID-外键","isQuery":"1","updateTime":1646025229000,"sort":2,"list":true,"params":{},"javaType":"Long","queryType":"LIKE","columnType":"bigint","createBy":"admin","createTime":1646020948000,"isEdit":"1","tableId":3,"pk":false,"columnName":"fk_sys_user_id"},{"capJavaField":"IdNum","usableColumn":false,"columnId":14,"increment":false,"insert":true,"isList":"1","dictType":"","required":false,"superColumn":false,"updateBy":"","isInsert":"1","javaField":"idNum","htmlType":"input","edit":true,"query":true,"columnComment":"身份证号","isQuery":"1","updateTime":1646025229000,"sort":3,"list":true,"params":{},"javaType":"String","queryType":"LIKE","columnType":"varchar","createBy":"admin","createTime":1646020948000,"isEdit":"1","tableId":3,"pk":false,"columnName":"id_num"},{"capJavaField":"Remark","usableColumn":true,"columnId":15,"increment":false,"insert":true,"isList":"1","dictType":"","required":false,"superColumn":true,"updateBy":"","isInsert":"1","javaField":"remark","htmlType":"input","edit":true,"query":false,"columnComment":"备注","updateTime":1646025229000,"sort":4,"list":true,"params":{},"javaType":"String","queryType":"LIKE","columnType":"nvarc', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 14:21:48');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (33, N'代码生成', 8, N'com.ruoyi.generator.controller.GenController.batchGenCode()', N'GET', 1, N'admin', null, N'/tool/gen/batchGenCode', N'127.0.0.1', N'内网IP', N'{}', null, 0, null, N'2022-02-28 14:22:09');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (34, N'代码生成', 2, N'com.ruoyi.generator.controller.GenController.synchDb()', N'GET', 1, N'admin', null, N'/tool/gen/synchDb/hr_user_cv', N'127.0.0.1', N'内网IP', N'{tableName=hr_user_cv}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 14:32:14');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (35, N'代码生成', 2, N'com.ruoyi.generator.controller.GenController.editSave()', N'PUT', 1, N'admin', null, N'/tool/gen', N'127.0.0.1', N'内网IP', N'{"sub":false,"functionAuthor":"ruoyi","columns":[{"capJavaField":"UserCvUuid","usableColumn":false,"columnId":4,"increment":false,"insert":true,"required":false,"superColumn":false,"isInsert":"1","javaField":"userCvUuid","htmlType":"input","edit":false,"query":false,"updateTime":1646029934000,"sort":1,"list":false,"params":{},"javaType":"String","columnType":"nvarchar","createBy":"admin","isPk":"1","createTime":1646020254000,"tableId":2,"pk":true,"columnName":"user_cv_uuid"},{"capJavaField":"FkHrUserUuid","usableColumn":false,"columnId":5,"increment":false,"insert":true,"isList":"1","dictType":"","required":false,"superColumn":false,"isInsert":"1","javaField":"fkHrUserUuid","htmlType":"input","edit":true,"query":true,"columnComment":"用户（附表）UUID-外键","isQuery":"1","updateTime":1646029934000,"sort":2,"list":true,"params":{},"javaType":"String","columnType":"bigint","createBy":"admin","createTime":1646020254000,"isEdit":"1","tableId":2,"pk":false,"columnName":"fk_hr_user_uuid"},{"capJavaField":"OrderNum","usableColumn":true,"columnId":6,"increment":false,"insert":true,"isList":"1","dictType":"","required":false,"superColumn":true,"isInsert":"1","javaField":"orderNum","htmlType":"input","edit":true,"query":true,"columnComment":"序号","isQuery":"1","updateTime":1646029934000,"sort":3,"list":true,"params":{},"javaType":"String","columnType":"nvarchar","createBy":"admin","createTime":1646020254000,"isEdit":"1","tableId":2,"pk":false,"columnName":"order_num"},{"capJavaField":"BeginAt","usableColumn":false,"columnId":7,"increment":false,"insert":true,"isList":"1","dictType":"","required":false,"superColumn":false,"isInsert":"1","javaField":"beginAt","htmlType":"datetime","edit":true,"query":true,"columnComment":"开始时间","isQuery":"1","updateTime":1646029934000,"sort":4,"list":true,"params":{},"javaType":"Date","columnType":"datetime","createBy":"admin","createTime":1646020254000,"isEdit":"1","tableId":2,"pk":false,"columnName":"begin_at"},{"capJavaField":"EndAt","usableColumn":fa', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 14:32:33');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (36, N'代码生成', 8, N'com.ruoyi.generator.controller.GenController.batchGenCode()', N'GET', 1, N'admin', null, N'/tool/gen/batchGenCode', N'127.0.0.1', N'内网IP', N'{}', null, 0, null, N'2022-02-28 14:32:41');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (37, N'代码生成', 2, N'com.ruoyi.generator.controller.GenController.editSave()', N'PUT', 1, N'admin', null, N'/tool/gen', N'127.0.0.1', N'内网IP', N'{"sub":true,"subTableName":"hr_user_cv","functionAuthor":"ruoyi","columns":[{"capJavaField":"UserUuid","usableColumn":false,"columnId":12,"increment":false,"insert":true,"dictType":"","required":false,"superColumn":false,"updateBy":"","isInsert":"1","javaField":"userUuid","htmlType":"input","edit":false,"query":false,"columnComment":"主键","updateTime":1646029308000,"sort":1,"list":false,"params":{},"javaType":"String","queryType":"EQ","columnType":"varchar","createBy":"admin","isPk":"1","createTime":1646020948000,"tableId":3,"pk":true,"columnName":"user_uuid"},{"capJavaField":"FkSysUserId","usableColumn":false,"columnId":13,"increment":false,"insert":true,"isList":"1","dictType":"","required":false,"superColumn":false,"updateBy":"","isInsert":"1","javaField":"fkSysUserId","htmlType":"input","edit":true,"query":true,"columnComment":"系统用户ID-外键","isQuery":"1","updateTime":1646029308000,"sort":2,"list":true,"params":{},"javaType":"Long","queryType":"LIKE","columnType":"bigint","createBy":"admin","createTime":1646020948000,"isEdit":"1","tableId":3,"pk":false,"columnName":"fk_sys_user_id"},{"capJavaField":"IdNum","usableColumn":false,"columnId":14,"increment":false,"insert":true,"isList":"1","dictType":"","required":false,"superColumn":false,"updateBy":"","isInsert":"1","javaField":"idNum","htmlType":"input","edit":true,"query":true,"columnComment":"身份证号","isQuery":"1","updateTime":1646029308000,"sort":3,"list":true,"params":{},"javaType":"String","queryType":"LIKE","columnType":"varchar","createBy":"admin","createTime":1646020948000,"isEdit":"1","tableId":3,"pk":false,"columnName":"id_num"},{"capJavaField":"Remark","usableColumn":true,"columnId":15,"increment":false,"insert":true,"isList":"1","dictType":"","required":false,"superColumn":true,"updateBy":"","isInsert":"1","javaField":"remark","htmlType":"input","edit":true,"query":false,"columnComment":"备注","updateTime":1646029308000,"sort":4,"list":true,"params":{},"javaType":"String","queryType":"LIKE","columnType":"nvarc', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 14:38:44');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (38, N'代码生成', 8, N'com.ruoyi.generator.controller.GenController.batchGenCode()', N'GET', 1, N'admin', null, N'/tool/gen/batchGenCode', N'127.0.0.1', N'内网IP', N'{}', null, 0, null, N'2022-02-28 14:38:53');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (39, N'用户-附表', 2, N'com.ruoyi.hr.controller.HrUserController.edit()', N'PUT', 1, N'admin', null, N'/hr/hrUser', N'127.0.0.1', N'内网IP', N'{"hrUserCvList":[],"fkSysUserId":1,"userUuid":"8861D30E-8953-4E5D-87EE-47A4BF08B8E2","remark":"","params":{},"idNum":"2"}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 14:59:43');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (40, N'用户-附表', 2, N'com.ruoyi.hr.controller.HrUserController.edit()', N'PUT', 1, N'admin', null, N'/hr/hrUser', N'127.0.0.1', N'内网IP', N'{"hrUserCvList":[],"fkSysUserId":1,"userUuid":"8861D30E-8953-4E5D-87EE-47A4BF08B8E2","remark":"3","params":{},"idNum":"2"}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 14:59:51');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (41, N'用户-附表', 2, N'com.ruoyi.hr.controller.HrUserController.edit()', N'PUT', 1, N'admin', null, N'/hr/hrUser', N'127.0.0.1', N'内网IP', N'{"hrUserCvList":[{"beginAt":1614441600000,"companyName":"1","orderNum":"1","remark":"1","endAt":1614441600000,"params":{},"fkHrUserUuid":"8861D30E-8953-4E5D-87EE-47A4BF08B8E2","fkSysPostId":1}],"fkSysUserId":1,"userUuid":"8861D30E-8953-4E5D-87EE-47A4BF08B8E2","remark":"3","params":{},"idNum":"2"}', null, 1, N'
### Error updating database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 不能将值 NULL 插入列 ''user_cv_uuid''，表 ''ry-vue.dbo.hr_user_cv''；列不允许有 Null 值。INSERT 失败。
### The error may exist in file [C:\Users\Livon\IdeaProjects\RuoYi-Vue-SQLServer\yunzhh-hr\target\classes\mapper\hr\HrUserMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: insert into hr_user_cv( user_cv_uuid, fk_hr_user_uuid, order_num, begin_at, end_at, company_name, fk_sys_post_id, remark) values                  ( ?, ?, ?, ?, ?, ?, ?, ?)
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 不能将值 NULL 插入列 ''user_cv_uuid''，表 ''ry-vue.dbo.hr_user_cv''；列不允许有 Null 值。INSERT 失败。
; 不能将值 NULL 插入列 ''user_cv_uuid''，表 ''ry-vue.dbo.hr_user_cv''；列不允许有 Null 值。INSERT 失败。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 不能将值 NULL 插入列 ''user_cv_uuid''，表 ''ry-vue.dbo.hr_user_cv''；列不允许有 Null 值。INSERT 失败。', N'2022-02-28 15:00:21');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (42, N'用户-附表', 2, N'com.ruoyi.hr.controller.HrUserController.edit()', N'PUT', 1, N'admin', null, N'/hr/hrUser', N'127.0.0.1', N'内网IP', N'{"hrUserCvList":[{"beginAt":1614441600000,"companyName":"1","orderNum":"1","remark":"1","endAt":1614441600000,"params":{},"fkHrUserUuid":"8861D30E-8953-4E5D-87EE-47A4BF08B8E2","fkSysPostId":1}],"fkSysUserId":1,"userUuid":"8861D30E-8953-4E5D-87EE-47A4BF08B8E2","remark":"3","params":{},"idNum":"2"}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 15:05:35');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (43, N'用户-附表', 1, N'com.ruoyi.hr.controller.HrUserController.add()', N'POST', 1, N'admin', null, N'/hr/hrUser', N'127.0.0.1', N'内网IP', N'{"hrUserCvList":[],"fkSysUserId":1,"remark":"1","params":{},"idNum":"1"}', null, 1, N'
### Error updating database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 不能将值 NULL 插入列 ''user_uuid''，表 ''ry-vue.dbo.hr_user''；列不允许有 Null 值。INSERT 失败。
### The error may exist in file [C:\Users\Livon\IdeaProjects\RuoYi-Vue-SQLServer\yunzhh-hr\target\classes\mapper\hr\HrUserMapper.xml]
### The error may involve com.ruoyi.hr.mapper.HrUserMapper.insertHrUser-Inline
### The error occurred while setting parameters
### SQL: insert into hr_user          ( fk_sys_user_id,             id_num,             remark )           values ( ?,             ?,             ? )
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 不能将值 NULL 插入列 ''user_uuid''，表 ''ry-vue.dbo.hr_user''；列不允许有 Null 值。INSERT 失败。
; 不能将值 NULL 插入列 ''user_uuid''，表 ''ry-vue.dbo.hr_user''；列不允许有 Null 值。INSERT 失败。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 不能将值 NULL 插入列 ''user_uuid''，表 ''ry-vue.dbo.hr_user''；列不允许有 Null 值。INSERT 失败。', N'2022-02-28 15:06:21');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (44, N'用户-附表', 1, N'com.ruoyi.hr.controller.HrUserController.add()', N'POST', 1, N'admin', null, N'/hr/hrUser', N'127.0.0.1', N'内网IP', N'{"hrUserCvList":[],"fkSysUserId":1,"remark":"1","params":{},"idNum":"1"}', null, 1, N'
### Error updating database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 不能将值 NULL 插入列 ''user_uuid''，表 ''ry-vue.dbo.hr_user''；列不允许有 Null 值。INSERT 失败。
### The error may exist in file [C:\Users\Livon\IdeaProjects\RuoYi-Vue-SQLServer\yunzhh-hr\target\classes\mapper\hr\HrUserMapper.xml]
### The error may involve com.ruoyi.hr.mapper.HrUserMapper.insertHrUser-Inline
### The error occurred while setting parameters
### SQL: insert into hr_user          ( fk_sys_user_id,             id_num,             remark )           values ( ?,             ?,             ? )
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 不能将值 NULL 插入列 ''user_uuid''，表 ''ry-vue.dbo.hr_user''；列不允许有 Null 值。INSERT 失败。
; 不能将值 NULL 插入列 ''user_uuid''，表 ''ry-vue.dbo.hr_user''；列不允许有 Null 值。INSERT 失败。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 不能将值 NULL 插入列 ''user_uuid''，表 ''ry-vue.dbo.hr_user''；列不允许有 Null 值。INSERT 失败。', N'2022-02-28 15:09:32');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (45, N'用户-附表', 1, N'com.ruoyi.hr.controller.HrUserController.add()', N'POST', 1, N'admin', null, N'/hr/hrUser', N'127.0.0.1', N'内网IP', N'{"hrUserCvList":[],"fkSysUserId":1,"remark":"1","params":{},"idNum":"1"}', null, 1, N'
### Error updating database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 不能将值 NULL 插入列 ''user_uuid''，表 ''ry-vue.dbo.hr_user''；列不允许有 Null 值。INSERT 失败。
### The error may exist in file [C:\Users\Livon\IdeaProjects\RuoYi-Vue-SQLServer\yunzhh-hr\target\classes\mapper\hr\HrUserMapper.xml]
### The error may involve com.ruoyi.hr.mapper.HrUserMapper.insertHrUser-Inline
### The error occurred while setting parameters
### SQL: insert into hr_user          ( fk_sys_user_id,             id_num,             remark )           values ( ?,             ?,             ? )
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 不能将值 NULL 插入列 ''user_uuid''，表 ''ry-vue.dbo.hr_user''；列不允许有 Null 值。INSERT 失败。
; 不能将值 NULL 插入列 ''user_uuid''，表 ''ry-vue.dbo.hr_user''；列不允许有 Null 值。INSERT 失败。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 不能将值 NULL 插入列 ''user_uuid''，表 ''ry-vue.dbo.hr_user''；列不允许有 Null 值。INSERT 失败。', N'2022-02-28 15:10:33');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (46, N'用户-附表', 1, N'com.ruoyi.hr.controller.HrUserController.add()', N'POST', 1, N'admin', null, N'/hr/hrUser', N'127.0.0.1', N'内网IP', N'{"hrUserCvList":[],"fkSysUserId":1,"remark":"1","params":{},"idNum":"1"}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 15:13:13');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (47, N'用户-附表', 2, N'com.ruoyi.hr.controller.HrUserController.edit()', N'PUT', 1, N'admin', null, N'/hr/hrUser', N'127.0.0.1', N'内网IP', N'{"hrUserCvList":[],"fkSysUserId":1,"userUuid":"AB4DEA11-4293-42CA-84A3-B087FDA98277","remark":"dd","params":{},"idNum":"1"}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 15:13:23');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (48, N'用户-附表', 1, N'com.ruoyi.hr.controller.HrUserController.add()', N'POST', 1, N'admin', null, N'/hr/hrUser', N'127.0.0.1', N'内网IP', N'{"hrUserCvList":[],"fkSysUserId":2,"remark":"ddd","params":{},"idNum":"2"}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 15:13:33');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (49, N'用户-附表', 1, N'com.ruoyi.hr.controller.HrUserController.add()', N'POST', 1, N'admin', null, N'/hr/hrUser', N'127.0.0.1', N'内网IP', N'{"hrUserCvList":[],"fkSysUserId":5,"remark":"ddddd","params":{},"idNum":"d"}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 15:13:52');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (50, N'用户-附表', 3, N'com.ruoyi.hr.controller.HrUserController.remove()', N'DELETE', 1, N'admin', null, N'/hr/hrUser/8CF89509-658C-41B5-A1C7-1E13E7559EAC', N'127.0.0.1', N'内网IP', N'{userUuids=8CF89509-658C-41B5-A1C7-1E13E7559EAC}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 15:13:58');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (51, N'用户-附表', 3, N'com.ruoyi.hr.controller.HrUserController.remove()', N'DELETE', 1, N'admin', null, N'/hr/hrUser/AB4DEA11-4293-42CA-84A3-B087FDA98277,14264859-F0D7-4CC8-8DC2-2BD44050D299', N'127.0.0.1', N'内网IP', N'{userUuids=AB4DEA11-4293-42CA-84A3-B087FDA98277,14264859-F0D7-4CC8-8DC2-2BD44050D299}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 15:14:10');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (52, N'用户-附表', 5, N'com.ruoyi.hr.controller.HrUserController.export()', N'POST', 1, N'admin', null, N'/hr/hrUser/export', N'127.0.0.1', N'内网IP', N'{"params":{}}', null, 0, null, N'2022-02-28 15:14:15');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (53, N'代码生成', 2, N'com.ruoyi.generator.controller.GenController.editSave()', N'PUT', 1, N'admin', null, N'/tool/gen', N'127.0.0.1', N'内网IP', N'{"sub":true,"subTableName":"hr_user_cv","functionAuthor":"ruoyi","columns":[{"capJavaField":"UserUuid","usableColumn":false,"columnId":12,"increment":false,"insert":true,"dictType":"","required":false,"superColumn":false,"updateBy":"","isInsert":"1","javaField":"userUuid","htmlType":"input","edit":false,"query":false,"columnComment":"主键","updateTime":1646030324000,"sort":1,"list":false,"params":{},"javaType":"String","queryType":"EQ","columnType":"varchar","createBy":"admin","isPk":"1","createTime":1646020948000,"tableId":3,"pk":true,"columnName":"user_uuid"},{"capJavaField":"FkSysUserId","usableColumn":false,"columnId":13,"increment":false,"insert":true,"isList":"1","dictType":"","required":false,"superColumn":false,"updateBy":"","isInsert":"1","javaField":"fkSysUserId","htmlType":"input","edit":true,"query":true,"columnComment":"系统用户ID-外键","isQuery":"1","updateTime":1646030324000,"sort":2,"list":true,"params":{},"javaType":"Long","queryType":"LIKE","columnType":"bigint","createBy":"admin","createTime":1646020948000,"isEdit":"1","tableId":3,"pk":false,"columnName":"fk_sys_user_id"},{"capJavaField":"IdNum","usableColumn":false,"columnId":14,"increment":false,"insert":true,"isList":"1","dictType":"","required":false,"superColumn":false,"updateBy":"","isInsert":"1","javaField":"idNum","htmlType":"input","edit":true,"query":true,"columnComment":"身份证号","isQuery":"1","updateTime":1646030324000,"sort":3,"list":true,"params":{},"javaType":"String","queryType":"LIKE","columnType":"varchar","createBy":"admin","createTime":1646020948000,"isEdit":"1","tableId":3,"pk":false,"columnName":"id_num"},{"capJavaField":"Remark","usableColumn":true,"columnId":15,"increment":false,"insert":true,"isList":"1","dictType":"","required":false,"superColumn":true,"updateBy":"","isInsert":"1","javaField":"remark","htmlType":"input","edit":true,"query":true,"columnComment":"备注","isQuery":"1","updateTime":1646030324000,"sort":4,"list":true,"params":{},"javaType":"String","queryType":"LIKE","colum', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 15:17:58');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (54, N'用户-附表', 2, N'com.ruoyi.hr.controller.HrUserController.edit()', N'PUT', 1, N'admin', null, N'/hr/hrUser', N'127.0.0.1', N'内网IP', N'{"hrUserCvList":[],"fkSysUserId":1,"userUuid":"650185A2-88CE-453C-91CF-3BC1DE9161C4","remark":"","params":{},"idNum":"210106197507130010"}', null, 1, N'
### Error updating database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 将截断字符串或二进制数据。
### The error may exist in file [C:\Users\Livon\IdeaProjects\RuoYi-Vue-SQLServer\yunzhh-hr\target\classes\mapper\hr\HrUserMapper.xml]
### The error may involve com.ruoyi.hr.mapper.HrUserMapper.updateHrUser-Inline
### The error occurred while setting parameters
### SQL: update hr_user          SET fk_sys_user_id = ?,             id_num = ?,             remark = ?          where user_uuid = ?
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 将截断字符串或二进制数据。
; 将截断字符串或二进制数据。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 将截断字符串或二进制数据。', N'2022-02-28 15:21:14');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (55, N'用户-附表', 2, N'com.ruoyi.hr.controller.HrUserController.edit()', N'PUT', 1, N'admin', null, N'/hr/hrUser', N'127.0.0.1', N'内网IP', N'{"hrUserCvList":[],"fkSysUserId":1,"userUuid":"650185A2-88CE-453C-91CF-3BC1DE9161C4","remark":"","params":{},"idNum":"210106197507130010"}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 15:21:47');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (56, N'用户管理', 1, N'com.ruoyi.web.controller.system.SysUserController.add()', N'POST', 1, N'admin', null, N'/system/user', N'127.0.0.1', N'内网IP', N'{"admin":false,"password":"$2a$10$fUhl8bGfDsQm7ry6aKxVQuti9ShvOZjc2rj0DhqtJ4IgEkMI.2FBG","postIds":[],"nickName":"研发1","deptId":103,"params":{},"userName":"dev1","userId":4,"createBy":"admin","roleIds":[],"status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 20:36:37');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (57, N'角色管理', 1, N'com.ruoyi.web.controller.system.SysRoleController.add()', N'POST', 1, N'admin', null, N'/system/role', N'127.0.0.1', N'内网IP', N'{"flag":false,"roleId":4,"admin":false,"params":{},"roleSort":"0","deptCheckStrictly":true,"createBy":"admin","menuCheckStrictly":true,"roleKey":"dev1","roleName":"研发1","deptIds":[],"menuIds":[],"status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-02-28 20:36:59');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (58, N'用户管理', 1, N'com.ruoyi.web.controller.system.SysUserController.add()', N'POST', 1, N'admin', null, N'/system/user', N'127.0.0.1', N'内网IP', N'{"admin":false,"password":"$2a$10$TDvmZebRBU2bNqAGTCImkuU71MySNk4hc6o8jNaR.DKNMYuFVmjmG","postIds":[],"nickName":"市场1","deptId":104,"params":{},"userName":"market1","userId":5,"createBy":"admin","roleIds":[],"status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-03-01 10:00:17');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (59, N'用户管理', 4, N'com.ruoyi.web.controller.system.SysUserController.insertAuthRole()', N'PUT', 1, N'admin', null, N'/system/user/authRole', N'127.0.0.1', N'内网IP', N'4 [4]', N'{"msg":"操作成功","code":200}', 0, null, N'2022-03-01 10:00:53');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (60, N'角色管理', 1, N'com.ruoyi.web.controller.system.SysRoleController.add()', N'POST', 1, N'admin', null, N'/system/role', N'127.0.0.1', N'内网IP', N'{"flag":false,"roleId":5,"admin":false,"params":{},"roleSort":"0","deptCheckStrictly":true,"createBy":"admin","menuCheckStrictly":true,"roleKey":"market1","roleName":"市场1","deptIds":[],"menuIds":[1,100,1001,1002,1003,1004,1005,1006,1007,101,1008,1009,1010,1011,1012,102,1013,1014,1015,1016,103,1017,1018,1019,1020,104,1021,1022,1023,1024,1025,105,1026,1027,1028,1029,1030,106,1031,1032,1033,1034,1035,107,1036,1037,1038,1039,108,500,1040,1041,1042,501,1043,1044,1045],"status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-03-01 10:01:41');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (61, N'角色管理', 2, N'com.ruoyi.web.controller.system.SysRoleController.edit()', N'PUT', 1, N'admin', null, N'/system/role', N'127.0.0.1', N'内网IP', N'{"flag":false,"roleId":4,"admin":false,"dataScope":"1","delFlag":"0","params":{},"roleSort":"0","deptCheckStrictly":true,"createTime":1646051819000,"updateBy":"admin","menuCheckStrictly":true,"roleKey":"dev1","roleName":"研发1","menuIds":[1,100,1001,1002,1003,1004,1005,1006,1007,101,1008,1009,1010,1011,1012,102,1013,1014,1015,1016,103,1017,1018,1019,1020,104,1021,1022,1023,1024,1025,105,1026,1027,1028,1029,1030,106,1031,1032,1033,1034,1035,107,1036,1037,1038,1039,108,500,1040,1041,1042,501,1043,1044,1045],"status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-03-01 10:01:57');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (62, N'用户管理', 4, N'com.ruoyi.web.controller.system.SysUserController.insertAuthRole()', N'PUT', 1, N'admin', null, N'/system/user/authRole', N'127.0.0.1', N'内网IP', N'5 [5]', N'{"msg":"操作成功","code":200}', 0, null, N'2022-03-01 10:05:02');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (63, N'角色管理', 2, N'com.ruoyi.web.controller.system.SysRoleController.dataScope()', N'PUT', 1, N'admin', null, N'/system/role/dataScope', N'127.0.0.1', N'内网IP', N'{"flag":false,"roleId":4,"admin":false,"dataScope":"3","delFlag":"0","params":{},"roleSort":"0","deptCheckStrictly":true,"createTime":1646051819000,"menuCheckStrictly":true,"roleKey":"dev1","roleName":"研发1","deptIds":[],"status":"0"}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-03-01 10:06:43');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (64, N'用户管理', 4, N'com.ruoyi.web.controller.system.SysUserController.insertAuthRole()', N'PUT', 1, N'admin', null, N'/system/user/authRole', N'127.0.0.1', N'内网IP', N'4 [4,5]', N'{"msg":"操作成功","code":200}', 0, null, N'2022-03-01 10:07:36');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (65, N'用户管理', 4, N'com.ruoyi.web.controller.system.SysUserController.insertAuthRole()', N'PUT', 1, N'admin', null, N'/system/user/authRole', N'127.0.0.1', N'内网IP', N'4 [4]', N'{"msg":"操作成功","code":200}', 0, null, N'2022-03-01 10:08:33');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (66, N'用户-附表', 1, N'com.ruoyi.hr.controller.HrUserController.add()', N'POST', 1, N'admin', null, N'/hr/hrUser', N'127.0.0.1', N'内网IP', N'{"fkSysUserId":4,"admin":false,"remark":"777","idNum":"666","params":{},"hrUserCvList":[]}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-03-01 14:39:11');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (67, N'用户-附表', 2, N'com.ruoyi.hr.controller.HrUserController.edit()', N'PUT', 1, N'admin', null, N'/hr/hrUser', N'127.0.0.1', N'内网IP', N'{"fkSysUserId":2,"admin":false,"remark":"","idNum":"210106197507130010","params":{},"hrUserCvList":[],"userUuid":"650185A2-88CE-453C-91CF-3BC1DE9161C4"}', N'{"msg":"操作成功","code":200}', 0, null, N'2022-03-01 15:57:17');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (68, N'用户-附表', 1, N'com.ruoyi.hr.controller.HrUserController.add()', N'POST', 1, N'admin', null, N'/hr/hrUser', N'127.0.0.1', N'内网IP', N'{"fkSysUserId":1,"admin":false,"idNum":"777","params":{},"hrUserCvList":[]}', null, 1, N'
### Error updating database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 不能在具有唯一索引“hr_user_fk_sys_user_id_uindex”的对象“dbo.hr_user”中插入重复键的行。重复键值为 (1)。
### The error may exist in file [C:\Users\Livon\IdeaProjects\RuoYi-Vue-SQLServer\yunzhh-hr\target\classes\mapper\hr\HrUserMapper.xml]
### The error may involve com.ruoyi.hr.mapper.HrUserMapper.insertHrUser-Inline
### The error occurred while setting parameters
### SQL: insert into hr_user          ( user_uuid,             fk_sys_user_id,             id_num )           values ( NEWID(),             ?,             ? )
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 不能在具有唯一索引“hr_user_fk_sys_user_id_uindex”的对象“dbo.hr_user”中插入重复键的行。重复键值为 (1)。
; 不能在具有唯一索引“hr_user_fk_sys_user_id_uindex”的对象“dbo.hr_user”中插入重复键的行。重复键值为 (1)。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 不能在具有唯一索引“hr_user_fk_sys_user_id_uindex”的对象“dbo.hr_user”中插入重复键的行。重复键值为 (1)。', N'2022-03-01 15:58:09');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (69, N'用户-附表', 1, N'com.ruoyi.hr.controller.HrUserController.add()', N'POST', 1, N'admin', null, N'/hr/hrUser', N'127.0.0.1', N'内网IP', N'{"fkSysUserId":1,"admin":false,"idNum":"777","params":{},"hrUserCvList":[]}', null, 1, N'
### Error updating database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 不能在具有唯一索引“hr_user_fk_sys_user_id_uindex”的对象“dbo.hr_user”中插入重复键的行。重复键值为 (1)。
### The error may exist in file [C:\Users\Livon\IdeaProjects\RuoYi-Vue-SQLServer\yunzhh-hr\target\classes\mapper\hr\HrUserMapper.xml]
### The error may involve com.ruoyi.hr.mapper.HrUserMapper.insertHrUser-Inline
### The error occurred while setting parameters
### SQL: insert into hr_user          ( user_uuid,             fk_sys_user_id,             id_num )           values ( NEWID(),             ?,             ? )
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 不能在具有唯一索引“hr_user_fk_sys_user_id_uindex”的对象“dbo.hr_user”中插入重复键的行。重复键值为 (1)。
; 不能在具有唯一索引“hr_user_fk_sys_user_id_uindex”的对象“dbo.hr_user”中插入重复键的行。重复键值为 (1)。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 不能在具有唯一索引“hr_user_fk_sys_user_id_uindex”的对象“dbo.hr_user”中插入重复键的行。重复键值为 (1)。', N'2022-03-01 15:58:22');
INSERT INTO [ry-vue].dbo.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time) VALUES (70, N'用户管理', 5, N'com.ruoyi.web.controller.system.SysUserController.export()', N'POST', 1, N'admin', null, N'/system/user/export', N'127.0.0.1', N'内网IP', N'{"admin":false,"params":{"dataScope":""}}', null, 0, null, N'2022-03-01 16:01:25');